<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

$bid = $_GET['bid'];
$roll_id = $_GET['roll_id'];
$conn = mysqli_connect('localhost', 'root', 'root', 'isc', '3306');
if (!$conn) {
    die('Could not connect to MySQL: ' . mysqli_connect_error());
}
mysqli_query($conn, 'SET NAMES \'UTF-8\'');

 $result = mysqli_query("DELETE FROM bookingrecord WHERE roll_id = '$roll_id' AND bid='$bid'");

if ($result){
    echo "Cancel sucess";
}
else echo "server has been eorror. ";

include_once('Mysql_unconnect.inc'); //断开连接
?>
